<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%@ page import="java.sql.*" %>
<%@ page import="javax.sql.*" %>
<%@ page import="javax.naming.*" %><%


Context ctx = null;
DataSource ds = null;
Connection conn = null;
PreparedStatement handle=null;
ResultSet rs = null;


   String strsql="";

try{
	ctx = new InitialContext();
	if(!m_strLoginCityID.equals("999"))
       {
         ds = (DataSource)ctx.lookup("java:comp/env/jdbc/omart"+m_strLoginCityID);
       }
       else
       {
         ds = (DataSource)ctx.lookup("java:comp/env/jdbc/oracle");
       }
	conn = ds.getConnection();
	handle=conn.createStatement();

}catch(Exception e){
	System.out.println(e.getMessage());
	out.write("<script language=vbscript>\n msgbox \"database error\"\n</script>\n");
}


   try
	{
%>
